Overview

Brought to you by YData

Dataset statistics

Number of variables	34
Number of observations	58913
Missing cells	172147
Missing cells (%)	8.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.3 MiB
Average record size in memory	272.0 B

Variable types

Numeric	7
DateTime	4
Categorical	12
Text	10
Unsupported	1

Alerts

`agency` has constant value "DOHMH"	Constant
`agency_name` has constant value "Department of Health and Mental Hygiene"	Constant
`complaint_type` has constant value "Food Establishment"	Constant
`bbl` is highly overall correlated with `borough` and 2 other fields	High correlation
`borough` is highly overall correlated with `bbl` and 6 other fields	High correlation
`incident_zip` is highly overall correlated with `bbl` and 4 other fields	High correlation
`latitude` is highly overall correlated with `borough` and 2 other fields	High correlation
`longitude` is highly overall correlated with `borough` and 3 other fields	High correlation
`park_borough` is highly overall correlated with `bbl` and 6 other fields	High correlation
`resolution_description` is highly overall correlated with `status`	High correlation
`status` is highly overall correlated with `resolution_description` and 1 other fields	High correlation
`unique_key` is highly overall correlated with `status`	High correlation
`x_coordinate_state_plane` is highly overall correlated with `borough` and 3 other fields	High correlation
`y_coordinate_state_plane` is highly overall correlated with `borough` and 2 other fields	High correlation
`location_type` is highly imbalanced (84.5%)	Imbalance
`address_type` is highly imbalanced (90.8%)	Imbalance
`status` is highly imbalanced (67.2%)	Imbalance
`park_facility_name` is highly imbalanced (99.9%)	Imbalance
`resolution_description` is highly imbalanced (87.0%)	Imbalance
`incident_zip` has 1566 (2.7%) missing values	Missing
`incident_address` has 1594 (2.7%) missing values	Missing
`street_name` has 1700 (2.9%) missing values	Missing
`cross_street_1` has 2381 (4.0%) missing values	Missing
`cross_street_2` has 2375 (4.0%) missing values	Missing
`intersection_street_1` has 4075 (6.9%) missing values	Missing
`intersection_street_2` has 4068 (6.9%) missing values	Missing
`address_type` has 1949 (3.3%) missing values	Missing
`city` has 2100 (3.6%) missing values	Missing
`landmark` has 7431 (12.6%) missing values	Missing
`bbl` has 4054 (6.9%) missing values	Missing
`x_coordinate_state_plane` has 1566 (2.7%) missing values	Missing
`y_coordinate_state_plane` has 1564 (2.7%) missing values	Missing
`latitude` has 1569 (2.7%) missing values	Missing
`longitude` has 1569 (2.7%) missing values	Missing
`location` has 1569 (2.7%) missing values	Missing
`closed_date` has 6875 (11.7%) missing values	Missing
`resolution_description` has 5769 (9.8%) missing values	Missing
`resolution_action_updated_date` has 5769 (9.8%) missing values	Missing
`due_date` has 53677 (91.1%) missing values	Missing
`facility_type` has 58913 (100.0%) missing values	Missing
`unique_key` has unique values	Unique
`facility_type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-11-19 05:02:10.371907
Analysis finished	2024-11-19 05:45:56.688048
Duration	43 minutes and 46.32 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

unique_key
Real number (ℝ)

High correlation Unique

Distinct	58913
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52693783

Minimum	41307236
Maximum	62607416
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.4 KiB

Quantile statistics

Minimum	41307236
5-th percentile	42235314
Q1	46443669
median	53699381
Q3	58293912
95-th percentile	61841452
Maximum	62607416
Range	21300180
Interquartile range (IQR)	11850243

Descriptive statistics

Standard deviation	6438895.9
Coefficient of variation (CV)	0.1221946
Kurtosis	-1.2598773
Mean	52693783
Median Absolute Deviation (MAD)	5638417
Skewness	-0.20788897
Sum	3.1043488 × 10¹²
Variance	4.145938 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41307236	1	< 0.1%
41318285	1	< 0.1%
41316446	1	< 0.1%
41316887	1	< 0.1%
41318573	1	< 0.1%
41317956	1	< 0.1%
41315009	1	< 0.1%
41318163	1	< 0.1%
41319075	1	< 0.1%
41317825	1	< 0.1%
Other values (58903)	58903	> 99.9%

Value	Count	Frequency (%)
41307236	1	< 0.1%
41314791	1	< 0.1%
41314982	1	< 0.1%
41315009	1	< 0.1%
41315010	1	< 0.1%
41315466	1	< 0.1%
41316420	1	< 0.1%
41316445	1	< 0.1%
41316446	1	< 0.1%
41316449	1	< 0.1%

Value	Count	Frequency (%)
62607416	1	< 0.1%
62607315	1	< 0.1%
62606493	1	< 0.1%
62606492	1	< 0.1%
62606141	1	< 0.1%
62605637	1	< 0.1%
62605571	1	< 0.1%
62605500	1	< 0.1%
62604774	1	< 0.1%
62604570	1	< 0.1%

created_date
Date

Distinct	58896
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

Minimum	2019-01-01 01:17:04
Maximum	2024-09-29 23:42:42

Histogram with fixed size bins (bins=50)

agency
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

DOHMH	58913

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	294565
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DOHMH
2nd row	DOHMH
3rd row	DOHMH
4th row	DOHMH
5th row	DOHMH

Common Values

Value	Count	Frequency (%)
DOHMH	58913	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dohmh	58913	100.0%

Most occurring characters

Value	Count	Frequency (%)
H	117826	40.0%
D	58913	20.0%
O	58913	20.0%
M	58913	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	294565	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
H	117826	40.0%
D	58913	20.0%
O	58913	20.0%
M	58913	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	294565	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
H	117826	40.0%
D	58913	20.0%
O	58913	20.0%
M	58913	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	294565	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
H	117826	40.0%
D	58913	20.0%
O	58913	20.0%
M	58913	20.0%

agency_name
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

Department of Health and Mental Hygiene	58913

Length

Max length	39
Median length	39
Mean length	39
Min length	39

Characters and Unicode

Total characters	2297607
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Department of Health and Mental Hygiene
2nd row	Department of Health and Mental Hygiene
3rd row	Department of Health and Mental Hygiene
4th row	Department of Health and Mental Hygiene
5th row	Department of Health and Mental Hygiene

Common Values

Value	Count	Frequency (%)
Department of Health and Mental Hygiene	58913	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
department	58913	16.7%
of	58913	16.7%
health	58913	16.7%
and	58913	16.7%
mental	58913	16.7%
hygiene	58913	16.7%

Most occurring characters

Value	Count	Frequency (%)
e	353478	15.4%
	294565	12.8%
a	235652	10.3%
n	235652	10.3%
t	235652	10.3%
l	117826	5.1%
H	117826	5.1%
p	58913	2.6%
D	58913	2.6%
m	58913	2.6%
Other values (9)	530217	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2297607	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	353478	15.4%
	294565	12.8%
a	235652	10.3%
n	235652	10.3%
t	235652	10.3%
l	117826	5.1%
H	117826	5.1%
p	58913	2.6%
D	58913	2.6%
m	58913	2.6%
Other values (9)	530217	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2297607	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	353478	15.4%
	294565	12.8%
a	235652	10.3%
n	235652	10.3%
t	235652	10.3%
l	117826	5.1%
H	117826	5.1%
p	58913	2.6%
D	58913	2.6%
m	58913	2.6%
Other values (9)	530217	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2297607	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	353478	15.4%
	294565	12.8%
a	235652	10.3%
n	235652	10.3%
t	235652	10.3%
l	117826	5.1%
H	117826	5.1%
p	58913	2.6%
D	58913	2.6%
m	58913	2.6%
Other values (9)	530217	23.1%

complaint_type
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

Food Establishment	58913

Length

Max length	18
Median length	18
Mean length	18
Min length	18

Characters and Unicode

Total characters	1060434
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Food Establishment
2nd row	Food Establishment
3rd row	Food Establishment
4th row	Food Establishment
5th row	Food Establishment

Common Values

Value	Count	Frequency (%)
Food Establishment	58913	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
food	58913	50.0%
establishment	58913	50.0%

Most occurring characters

Value	Count	Frequency (%)
o	117826	11.1%
s	117826	11.1%
t	117826	11.1%
d	58913	5.6%
F	58913	5.6%
E	58913	5.6%
	58913	5.6%
a	58913	5.6%
b	58913	5.6%
l	58913	5.6%
Other values (5)	294565	27.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1060434	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	117826	11.1%
s	117826	11.1%
t	117826	11.1%
d	58913	5.6%
F	58913	5.6%
E	58913	5.6%
	58913	5.6%
a	58913	5.6%
b	58913	5.6%
l	58913	5.6%
Other values (5)	294565	27.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1060434	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	117826	11.1%
s	117826	11.1%
t	117826	11.1%
d	58913	5.6%
F	58913	5.6%
E	58913	5.6%
	58913	5.6%
a	58913	5.6%
b	58913	5.6%
l	58913	5.6%
Other values (5)	294565	27.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1060434	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	117826	11.1%
s	117826	11.1%
t	117826	11.1%
d	58913	5.6%
F	58913	5.6%
E	58913	5.6%
	58913	5.6%
a	58913	5.6%
b	58913	5.6%
l	58913	5.6%
Other values (5)	294565	27.8%

descriptor
Categorical

Distinct	32
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

Rodents/Insects/Garbage	19324
Food Spoiled	4723
Bare Hands in Contact w/ Food	4699
Food Contaminated	3976
Letter Grading	3504
Other values (27)	22687

Length

Max length	29
Median length	25
Mean length	19.491521
Min length	4

Characters and Unicode

Total characters	1148304
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bare Hands in Contact w/ Food
2nd row	Rodents/Insects/Garbage
3rd row	Rodents/Insects/Garbage
4th row	Rodents/Insects/Garbage
5th row	Bare Hands in Contact w/ Food

Common Values

Value	Count	Frequency (%)
Rodents/Insects/Garbage	19324	32.8%
Food Spoiled	4723	8.0%
Bare Hands in Contact w/ Food	4699	8.0%
Food Contaminated	3976	6.7%
Letter Grading	3504	5.9%
No Permit or License	2843	4.8%
Pet/Animal	2683	4.6%
Food Worker Hygiene	2434	4.1%
Food Contains Foreign Object	2278	3.9%
Kitchen/Food Prep Area	1963	3.3%
Other values (22)	10486	17.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
food	22225	17.5%
rodents/insects/garbage	19324	15.2%
spoiled	4723	3.7%
bare	4699	3.7%
hands	4699	3.7%
in	4699	3.7%
contact	4699	3.7%
w	4699	3.7%
contaminated	3976	3.1%
letter	3504	2.8%
Other values (43)	49535	39.1%

Most occurring characters

Value	Count	Frequency (%)
e	120934	10.5%
o	104044	9.1%
t	89063	7.8%
n	88461	7.7%
a	80050	7.0%
s	71805	6.3%
	67869	5.9%
d	62604	5.5%
r	58592	5.1%
/	49676	4.3%
Other values (37)	355206	30.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1148304	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	120934	10.5%
o	104044	9.1%
t	89063	7.8%
n	88461	7.7%
a	80050	7.0%
s	71805	6.3%
	67869	5.9%
d	62604	5.5%
r	58592	5.1%
/	49676	4.3%
Other values (37)	355206	30.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1148304	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	120934	10.5%
o	104044	9.1%
t	89063	7.8%
n	88461	7.7%
a	80050	7.0%
s	71805	6.3%
	67869	5.9%
d	62604	5.5%
r	58592	5.1%
/	49676	4.3%
Other values (37)	355206	30.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1148304	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	120934	10.5%
o	104044	9.1%
t	89063	7.8%
n	88461	7.7%
a	80050	7.0%
s	71805	6.3%
	67869	5.9%
d	62604	5.5%
r	58592	5.1%
/	49676	4.3%
Other values (37)	355206	30.9%

location_type
Categorical

Imbalance

Distinct	40
Distinct (%)	0.1%
Missing	14
Missing (%)	< 0.1%
Memory size	460.4 KiB

Restaurant/Bar/Deli/Bakery	52088
Other (Explain Below)	3654
1-2 Family Dwelling	759
Restaurant	713
Catering Service	266
Other values (35)	1419

Length

Max length	36
Median length	26
Mean length	25.182074
Min length	5

Characters and Unicode

Total characters	1483199
Distinct characters	50
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	Restaurant/Bar/Deli/Bakery
2nd row	Restaurant/Bar/Deli/Bakery
3rd row	Restaurant/Bar/Deli/Bakery
4th row	Restaurant/Bar/Deli/Bakery
5th row	Restaurant/Bar/Deli/Bakery

Common Values

Value	Count	Frequency (%)
Restaurant/Bar/Deli/Bakery	52088	88.4%
Other (Explain Below)	3654	6.2%
1-2 Family Dwelling	759	1.3%
Restaurant	713	1.2%
Catering Service	266	0.5%
Other (explain in Complaint Details)	210	0.4%
Commercial Building	153	0.3%
Store	145	0.2%
Residence	142	0.2%
Cafeteria - College/University	101	0.2%
Other values (30)	668	1.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
restaurant/bar/deli/bakery	52088	74.1%
other	3954	5.6%
explain	3864	5.5%
below	3654	5.2%
family	832	1.2%
1-2	808	1.2%
dwelling	759	1.1%
restaurant	713	1.0%
catering	278	0.4%
service	266	0.4%
Other values (48)	3034	4.3%

Most occurring characters

Value	Count	Frequency (%)
a	216044	14.6%
e	169034	11.4%
r	162803	11.0%
/	156366	10.5%
t	111321	7.5%
B	108076	7.3%
l	63155	4.3%
i	60359	4.1%
n	59058	4.0%
s	53339	3.6%
Other values (40)	323644	21.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1483199	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	216044	14.6%
e	169034	11.4%
r	162803	11.0%
/	156366	10.5%
t	111321	7.5%
B	108076	7.3%
l	63155	4.3%
i	60359	4.1%
n	59058	4.0%
s	53339	3.6%
Other values (40)	323644	21.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1483199	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	216044	14.6%
e	169034	11.4%
r	162803	11.0%
/	156366	10.5%
t	111321	7.5%
B	108076	7.3%
l	63155	4.3%
i	60359	4.1%
n	59058	4.0%
s	53339	3.6%
Other values (40)	323644	21.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1483199	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	216044	14.6%
e	169034	11.4%
r	162803	11.0%
/	156366	10.5%
t	111321	7.5%
B	108076	7.3%
l	63155	4.3%
i	60359	4.1%
n	59058	4.0%
s	53339	3.6%
Other values (40)	323644	21.8%

incident_zip
Real number (ℝ)

High correlation Missing

Distinct	211
Distinct (%)	0.4%
Missing	1566
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	10725.561

Minimum	10000
Maximum	12345
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.4 KiB

Quantile statistics

Minimum	10000
5-th percentile	10004
Q1	10028
median	11103
Q3	11232
95-th percentile	11419
Maximum	12345
Range	2345
Interquartile range (IQR)	1204

Descriptive statistics

Standard deviation	587.41274
Coefficient of variation (CV)	0.054767555
Kurtosis	-1.78548
Mean	10725.561
Median Absolute Deviation (MAD)	331
Skewness	-0.13598334
Sum	6.1507873 × 10⁸
Variance	345053.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10003	1175	2.0%
11355	1102	1.9%
11201	1048	1.8%
10019	1021	1.7%
10002	940	1.6%
10014	871	1.5%
10013	833	1.4%
10036	817	1.4%
11209	800	1.4%
10011	792	1.3%
Other values (201)	47948	81.4%
(Missing)	1566	2.7%

Value	Count	Frequency (%)
10000	6	< 0.1%
10001	738	1.3%
10002	940	1.6%
10003	1175	2.0%
10004	131	0.2%
10005	84	0.1%
10006	48	0.1%
10007	258	0.4%
10009	679	1.2%
10010	430	0.7%

Value	Count	Frequency (%)
12345	1	< 0.1%
11697	6	< 0.1%
11695	3	< 0.1%
11694	104	0.2%
11693	84	0.1%
11692	34	0.1%
11691	123	0.2%
11436	74	0.1%
11435	252	0.4%
11434	257	0.4%

incident_address
Text

Missing

Distinct	25182
Distinct (%)	43.9%
Missing	1594
Missing (%)	2.7%
Memory size	460.4 KiB

Length

Max length	38
Median length	33
Mean length	18.08095
Min length	1

Characters and Unicode

Total characters	1036382
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14513 ?
Unique (%)	25.3%

Sample

1st row	523 BRIGHTON BEACH AVENUE
2nd row	2117 WILLIAMBRIDGE ROAD
3rd row	31 WEST 32 STREET
4th row	114
5th row	2605 CONEY ISLAND AVENUE

Value	Count	Frequency (%)
avenue	26908	14.8%
street	17513	9.7%
boulevard	5281	2.9%
east	4002	2.2%
west	3669	2.0%
broadway	2497	1.4%
road	1907	1.1%
3	1295	0.7%
5	998	0.6%
1	976	0.5%
Other values (9424)	116197	64.1%

Most occurring characters

Value	Count	Frequency (%)
	134720	13.0%
E	127894	12.3%
A	68491	6.6%
T	62822	6.1%
N	51377	5.0%
R	50832	4.9%
1	44804	4.3%
S	42663	4.1%
U	40865	3.9%
V	34982	3.4%
Other values (30)	376932	36.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1036382	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	134720	13.0%
E	127894	12.3%
A	68491	6.6%
T	62822	6.1%
N	51377	5.0%
R	50832	4.9%
1	44804	4.3%
S	42663	4.1%
U	40865	3.9%
V	34982	3.4%
Other values (30)	376932	36.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1036382	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	134720	13.0%
E	127894	12.3%
A	68491	6.6%
T	62822	6.1%
N	51377	5.0%
R	50832	4.9%
1	44804	4.3%
S	42663	4.1%
U	40865	3.9%
V	34982	3.4%
Other values (30)	376932	36.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1036382	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	134720	13.0%
E	127894	12.3%
A	68491	6.6%
T	62822	6.1%
N	51377	5.0%
R	50832	4.9%
1	44804	4.3%
S	42663	4.1%
U	40865	3.9%
V	34982	3.4%
Other values (30)	376932	36.4%

street_name
Text

Missing

Distinct	2574
Distinct (%)	4.5%
Missing	1700
Missing (%)	2.9%
Memory size	460.4 KiB

Length

Max length	32
Median length	29
Mean length	13.479506
Min length	3

Characters and Unicode

Total characters	771203
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	728 ?
Unique (%)	1.3%

Sample

1st row	BRIGHTON BEACH AVENUE
2nd row	WILLIAMBRIDGE ROAD
3rd row	WEST 32 STREET
4th row	CONEY ISLAND AVENUE
5th row	PROSPECT PARK WEST

Value	Count	Frequency (%)
avenue	26908	21.6%
street	17513	14.0%
boulevard	5281	4.2%
east	3997	3.2%
west	3661	2.9%
broadway	2497	2.0%
road	1907	1.5%
3	1261	1.0%
5	898	0.7%
8	884	0.7%
Other values (1524)	59885	48.0%

Most occurring characters

Value	Count	Frequency (%)
E	127862	16.6%
	78275	10.1%
A	68213	8.8%
T	62807	8.1%
N	51373	6.7%
R	50830	6.6%
S	42637	5.5%
U	40865	5.3%
V	34982	4.5%
O	29965	3.9%
Other values (29)	183394	23.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	771203	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	127862	16.6%
	78275	10.1%
A	68213	8.8%
T	62807	8.1%
N	51373	6.7%
R	50830	6.6%
S	42637	5.5%
U	40865	5.3%
V	34982	4.5%
O	29965	3.9%
Other values (29)	183394	23.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	771203	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	127862	16.6%
	78275	10.1%
A	68213	8.8%
T	62807	8.1%
N	51373	6.7%
R	50830	6.6%
S	42637	5.5%
U	40865	5.3%
V	34982	4.5%
O	29965	3.9%
Other values (29)	183394	23.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	771203	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	127862	16.6%
	78275	10.1%
A	68213	8.8%
T	62807	8.1%
N	51373	6.7%
R	50830	6.6%
S	42637	5.5%
U	40865	5.3%
V	34982	4.5%
O	29965	3.9%
Other values (29)	183394	23.8%

cross_street_1
Text

Missing

Distinct	4021
Distinct (%)	7.1%
Missing	2381
Missing (%)	4.0%
Memory size	460.4 KiB

Length

Max length	32
Median length	29
Mean length	13.350403
Min length	4

Characters and Unicode

Total characters	754725
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	887 ?
Unique (%)	1.6%

Sample

1st row	BRIGHTON 5 STREET
2nd row	LYDIG AVENUE
3rd row	5 AVENUE
4th row	BERRY STRE
5th row	AVENUE W

Value	Count	Frequency (%)
street	28877	21.9%
avenue	18298	13.9%
east	6567	5.0%
west	5623	4.3%
place	2009	1.5%
road	1591	1.2%
boulevard	1242	0.9%
5	1158	0.9%
barclay	711	0.5%
broadway	700	0.5%
Other values (2541)	65057	49.3%

Most occurring characters

Value	Count	Frequency (%)
E	134512	17.8%
	96128	12.7%
T	83274	11.0%
A	53813	7.1%
R	53664	7.1%
S	53312	7.1%
N	37705	5.0%
U	24960	3.3%
V	21926	2.9%
O	20077	2.7%
Other values (33)	175354	23.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	754725	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	134512	17.8%
	96128	12.7%
T	83274	11.0%
A	53813	7.1%
R	53664	7.1%
S	53312	7.1%
N	37705	5.0%
U	24960	3.3%
V	21926	2.9%
O	20077	2.7%
Other values (33)	175354	23.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	754725	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	134512	17.8%
	96128	12.7%
T	83274	11.0%
A	53813	7.1%
R	53664	7.1%
S	53312	7.1%
N	37705	5.0%
U	24960	3.3%
V	21926	2.9%
O	20077	2.7%
Other values (33)	175354	23.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	754725	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	134512	17.8%
	96128	12.7%
T	83274	11.0%
A	53813	7.1%
R	53664	7.1%
S	53312	7.1%
N	37705	5.0%
U	24960	3.3%
V	21926	2.9%
O	20077	2.7%
Other values (33)	175354	23.2%

cross_street_2
Text

Missing

Distinct	4049
Distinct (%)	7.2%
Missing	2375
Missing (%)	4.0%
Memory size	460.4 KiB

Length

Max length	32
Median length	29
Mean length	13.42559
Min length	4

Characters and Unicode

Total characters	759056
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	910 ?
Unique (%)	1.6%

Sample

1st row	BRIGHTON 6 STREET
2nd row	PELHAM PARKWAY SOUTH
3rd row	BROADWAY
4th row	MIKE LEE
5th row	LANCASTER AVENUE

Value	Count	Frequency (%)
street	28887	21.8%
avenue	17975	13.6%
east	6567	5.0%
west	5907	4.5%
place	2072	1.6%
road	1896	1.4%
boulevard	1177	0.9%
broadway	746	0.6%
sanford	736	0.6%
3	681	0.5%
Other values (2525)	65600	49.6%

Most occurring characters

Value	Count	Frequency (%)
E	133901	17.6%
	96979	12.8%
T	84232	11.1%
S	54579	7.2%
R	53668	7.1%
A	52734	6.9%
N	39705	5.2%
U	24730	3.3%
O	22668	3.0%
V	21776	2.9%
Other values (33)	174084	22.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	759056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	133901	17.6%
	96979	12.8%
T	84232	11.1%
S	54579	7.2%
R	53668	7.1%
A	52734	6.9%
N	39705	5.2%
U	24730	3.3%
O	22668	3.0%
V	21776	2.9%
Other values (33)	174084	22.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	759056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	133901	17.6%
	96979	12.8%
T	84232	11.1%
S	54579	7.2%
R	53668	7.1%
A	52734	6.9%
N	39705	5.2%
U	24730	3.3%
O	22668	3.0%
V	21776	2.9%
Other values (33)	174084	22.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	759056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	133901	17.6%
	96979	12.8%
T	84232	11.1%
S	54579	7.2%
R	53668	7.1%
A	52734	6.9%
N	39705	5.2%
U	24730	3.3%
O	22668	3.0%
V	21776	2.9%
Other values (33)	174084	22.9%

intersection_street_1
Text

Missing

Distinct	3929
Distinct (%)	7.2%
Missing	4075
Missing (%)	6.9%
Memory size	460.4 KiB

Length

Max length	32
Median length	29
Mean length	13.372625
Min length	4

Characters and Unicode

Total characters	733328
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	894 ?
Unique (%)	1.6%

Sample

1st row	BRIGHTON 5 STREET
2nd row	LYDIG AVENUE
3rd row	5 AVENUE
4th row	BERRY STRE
5th row	AVENUE W

Value	Count	Frequency (%)
street	27986	21.9%
avenue	17785	13.9%
east	6352	5.0%
west	5414	4.2%
place	1949	1.5%
road	1522	1.2%
boulevard	1214	0.9%
5	1107	0.9%
barclay	711	0.6%
broadway	680	0.5%
Other values (2535)	63168	49.4%

Most occurring characters

Value	Count	Frequency (%)
E	130535	17.8%
	93911	12.8%
T	80684	11.0%
A	52269	7.1%
R	52125	7.1%
S	51662	7.0%
N	36693	5.0%
U	24257	3.3%
V	21341	2.9%
O	19518	2.7%
Other values (33)	170333	23.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	733328	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	130535	17.8%
	93911	12.8%
T	80684	11.0%
A	52269	7.1%
R	52125	7.1%
S	51662	7.0%
N	36693	5.0%
U	24257	3.3%
V	21341	2.9%
O	19518	2.7%
Other values (33)	170333	23.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	733328	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	130535	17.8%
	93911	12.8%
T	80684	11.0%
A	52269	7.1%
R	52125	7.1%
S	51662	7.0%
N	36693	5.0%
U	24257	3.3%
V	21341	2.9%
O	19518	2.7%
Other values (33)	170333	23.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	733328	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	130535	17.8%
	93911	12.8%
T	80684	11.0%
A	52269	7.1%
R	52125	7.1%
S	51662	7.0%
N	36693	5.0%
U	24257	3.3%
V	21341	2.9%
O	19518	2.7%
Other values (33)	170333	23.2%

intersection_street_2
Text

Missing

Distinct	3949
Distinct (%)	7.2%
Missing	4068
Missing (%)	6.9%
Memory size	460.4 KiB

Length

Max length	32
Median length	29
Mean length	13.447698
Min length	4

Characters and Unicode

Total characters	737539
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	915 ?
Unique (%)	1.7%

Sample

1st row	BRIGHTON 6 STREET
2nd row	PELHAM PARKWAY SOUTH
3rd row	BROADWAY
4th row	MIKE LEE
5th row	LANCASTER AVENUE

Value	Count	Frequency (%)
street	27982	21.8%
avenue	17471	13.6%
east	6350	5.0%
west	5696	4.4%
place	2008	1.6%
road	1833	1.4%
boulevard	1149	0.9%
sanford	734	0.6%
broadway	723	0.6%
3	647	0.5%
Other values (2513)	63679	49.6%

Most occurring characters

Value	Count	Frequency (%)
E	129948	17.6%
	94721	12.8%
T	81605	11.1%
S	52921	7.2%
R	52178	7.1%
A	51241	6.9%
N	38679	5.2%
U	24047	3.3%
O	22091	3.0%
V	21172	2.9%
Other values (33)	168936	22.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	737539	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	129948	17.6%
	94721	12.8%
T	81605	11.1%
S	52921	7.2%
R	52178	7.1%
A	51241	6.9%
N	38679	5.2%
U	24047	3.3%
O	22091	3.0%
V	21172	2.9%
Other values (33)	168936	22.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	737539	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	129948	17.6%
	94721	12.8%
T	81605	11.1%
S	52921	7.2%
R	52178	7.1%
A	51241	6.9%
N	38679	5.2%
U	24047	3.3%
O	22091	3.0%
V	21172	2.9%
Other values (33)	168936	22.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	737539	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	129948	17.6%
	94721	12.8%
T	81605	11.1%
S	52921	7.2%
R	52178	7.1%
A	51241	6.9%
N	38679	5.2%
U	24047	3.3%
O	22091	3.0%
V	21172	2.9%
Other values (33)	168936	22.9%

address_type
Categorical

Imbalance Missing

Distinct	6
Distinct (%)	< 0.1%
Missing	1949
Missing (%)	3.3%
Memory size	460.4 KiB

ADDRESS	55263
LATLONG	805
INTERSECTION	735
UNRECOGNIZED	123
BLOCKFACE	35

Length

Max length	12
Median length	7
Mean length	7.0766449
Min length	7

Characters and Unicode

Total characters	403114
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ADDRESS
2nd row	ADDRESS
3rd row	ADDRESS
4th row	ADDRESS
5th row	ADDRESS

Common Values

Value	Count	Frequency (%)
ADDRESS	55263	93.8%
LATLONG	805	1.4%
INTERSECTION	735	1.2%
UNRECOGNIZED	123	0.2%
BLOCKFACE	35	0.1%
PLACENAME	3	< 0.1%
(Missing)	1949	3.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
address	55263	97.0%
latlong	805	1.4%
intersection	735	1.3%
unrecognized	123	0.2%
blockface	35	0.1%
placename	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
S	111261	27.6%
D	110649	27.4%
E	57020	14.1%
R	56121	13.9%
A	56109	13.9%
N	2524	0.6%
T	2275	0.6%
O	1698	0.4%
L	1648	0.4%
I	1593	0.4%
Other values (9)	2216	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	403114	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	111261	27.6%
D	110649	27.4%
E	57020	14.1%
R	56121	13.9%
A	56109	13.9%
N	2524	0.6%
T	2275	0.6%
O	1698	0.4%
L	1648	0.4%
I	1593	0.4%
Other values (9)	2216	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	403114	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	111261	27.6%
D	110649	27.4%
E	57020	14.1%
R	56121	13.9%
A	56109	13.9%
N	2524	0.6%
T	2275	0.6%
O	1698	0.4%
L	1648	0.4%
I	1593	0.4%
Other values (9)	2216	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	403114	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	111261	27.6%
D	110649	27.4%
E	57020	14.1%
R	56121	13.9%
A	56109	13.9%
N	2524	0.6%
T	2275	0.6%
O	1698	0.4%
L	1648	0.4%
I	1593	0.4%
Other values (9)	2216	0.5%

city
Text

Missing

Distinct	56
Distinct (%)	0.1%
Missing	2100
Missing (%)	3.6%
Memory size	460.4 KiB

Length

Max length	19
Median length	8
Mean length	8.4094485
Min length	2

Characters and Unicode

Total characters	477766
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	BROOKLYN
2nd row	BRONX
3rd row	NEW YORK
4th row	Brooklyn
5th row	BROOKLYN

Value	Count	Frequency (%)
new	19424	22.8%
york	19410	22.7%
brooklyn	15888	18.6%
bronx	5705	6.7%
island	2938	3.4%
staten	2377	2.8%
flushing	2211	2.6%
astoria	1591	1.9%
jamaica	1246	1.5%
park	823	1.0%
Other values (52)	13712	16.1%

Most occurring characters

Value	Count	Frequency (%)
O	67492	14.1%
N	53053	11.1%
R	48319	10.1%
K	37347	7.8%
Y	36611	7.7%
E	29866	6.3%
	28512	6.0%
L	26898	5.6%
B	22255	4.7%
W	21490	4.5%
Other values (38)	105923	22.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	477766	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	67492	14.1%
N	53053	11.1%
R	48319	10.1%
K	37347	7.8%
Y	36611	7.7%
E	29866	6.3%
	28512	6.0%
L	26898	5.6%
B	22255	4.7%
W	21490	4.5%
Other values (38)	105923	22.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	477766	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	67492	14.1%
N	53053	11.1%
R	48319	10.1%
K	37347	7.8%
Y	36611	7.7%
E	29866	6.3%
	28512	6.0%
L	26898	5.6%
B	22255	4.7%
W	21490	4.5%
Other values (38)	105923	22.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	477766	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	67492	14.1%
N	53053	11.1%
R	48319	10.1%
K	37347	7.8%
Y	36611	7.7%
E	29866	6.3%
	28512	6.0%
L	26898	5.6%
B	22255	4.7%
W	21490	4.5%
Other values (38)	105923	22.2%

landmark
Text

Missing

Distinct	2080
Distinct (%)	4.0%
Missing	7431
Missing (%)	12.6%
Memory size	460.4 KiB

Length

Max length	32
Median length	29
Mean length	13.424556
Min length	6

Characters and Unicode

Total characters	691123
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	537 ?
Unique (%)	1.0%

Sample

1st row	BRIGHTON BEACH AVENUE
2nd row	WILLIAMSBRIDGE ROAD
3rd row	WEST 32 STREET
4th row	CONEY ISLAND AVENUE
5th row	PROSPECT PARK WEST

Value	Count	Frequency (%)
avenue	24476	21.8%
street	15759	14.0%
boulevard	4514	4.0%
east	3572	3.2%
west	3272	2.9%
broadway	2203	2.0%
road	1744	1.6%
3	1267	1.1%
8	962	0.9%
5	891	0.8%
Other values (1359)	53752	47.8%

Most occurring characters

Value	Count	Frequency (%)
E	115202	16.7%
	71719	10.4%
A	61195	8.9%
T	56125	8.1%
N	46278	6.7%
R	45270	6.6%
S	38258	5.5%
U	36657	5.3%
V	31459	4.6%
O	26530	3.8%
Other values (28)	162430	23.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	691123	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	115202	16.7%
	71719	10.4%
A	61195	8.9%
T	56125	8.1%
N	46278	6.7%
R	45270	6.6%
S	38258	5.5%
U	36657	5.3%
V	31459	4.6%
O	26530	3.8%
Other values (28)	162430	23.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	691123	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	115202	16.7%
	71719	10.4%
A	61195	8.9%
T	56125	8.1%
N	46278	6.7%
R	45270	6.6%
S	38258	5.5%
U	36657	5.3%
V	31459	4.6%
O	26530	3.8%
Other values (28)	162430	23.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	691123	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	115202	16.7%
	71719	10.4%
A	61195	8.9%
T	56125	8.1%
N	46278	6.7%
R	45270	6.6%
S	38258	5.5%
U	36657	5.3%
V	31459	4.6%
O	26530	3.8%
Other values (28)	162430	23.5%

status
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

Closed	52034
In Progress	6876
Unspecified	3

Length

Max length	11
Median length	6
Mean length	6.583827
Min length	6

Characters and Unicode

Total characters	387873
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	In Progress
2nd row	In Progress
3rd row	In Progress
4th row	In Progress
5th row	In Progress

Common Values

Value	Count	Frequency (%)
Closed	52034	88.3%
In Progress	6876	11.7%
Unspecified	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
closed	52034	79.1%
in	6876	10.5%
progress	6876	10.5%
unspecified	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
s	65789	17.0%
e	58916	15.2%
o	58910	15.2%
d	52037	13.4%
C	52034	13.4%
l	52034	13.4%
r	13752	3.5%
n	6879	1.8%
I	6876	1.8%
	6876	1.8%
Other values (7)	13770	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	387873	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	65789	17.0%
e	58916	15.2%
o	58910	15.2%
d	52037	13.4%
C	52034	13.4%
l	52034	13.4%
r	13752	3.5%
n	6879	1.8%
I	6876	1.8%
	6876	1.8%
Other values (7)	13770	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	387873	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	65789	17.0%
e	58916	15.2%
o	58910	15.2%
d	52037	13.4%
C	52034	13.4%
l	52034	13.4%
r	13752	3.5%
n	6879	1.8%
I	6876	1.8%
	6876	1.8%
Other values (7)	13770	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	387873	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	65789	17.0%
e	58916	15.2%
o	58910	15.2%
d	52037	13.4%
C	52034	13.4%
l	52034	13.4%
r	13752	3.5%
n	6879	1.8%
I	6876	1.8%
	6876	1.8%
Other values (7)	13770	3.6%

community_board
Text

Distinct	76
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

Length

Max length	25
Median length	21
Mean length	10.853479
Min length	8

Characters and Unicode

Total characters	639411
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	13 BROOKLYN
2nd row	11 BRONX
3rd row	05 MANHATTAN
4th row	Unspecified BROOKLYN
5th row	15 BROOKLYN

Value	Count	Frequency (%)
manhattan	19634	16.3%
brooklyn	16056	13.4%
queens	13576	11.3%
01	7043	5.9%
02	5849	4.9%
bronx	5782	4.8%
07	5535	4.6%
03	5212	4.3%
05	5012	4.2%
04	4048	3.4%
Other values (27)	32481	27.0%

Most occurring characters

Value	Count	Frequency (%)
N	79486	12.4%
A	63706	10.0%
	61315	9.6%
0	48035	7.5%
T	44072	6.9%
O	37894	5.9%
E	29554	4.6%
1	24060	3.8%
B	21838	3.4%
R	21838	3.4%
Other values (27)	207613	32.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	639411	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	79486	12.4%
A	63706	10.0%
	61315	9.6%
0	48035	7.5%
T	44072	6.9%
O	37894	5.9%
E	29554	4.6%
1	24060	3.8%
B	21838	3.4%
R	21838	3.4%
Other values (27)	207613	32.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	639411	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	79486	12.4%
A	63706	10.0%
	61315	9.6%
0	48035	7.5%
T	44072	6.9%
O	37894	5.9%
E	29554	4.6%
1	24060	3.8%
B	21838	3.4%
R	21838	3.4%
Other values (27)	207613	32.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	639411	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	79486	12.4%
A	63706	10.0%
	61315	9.6%
0	48035	7.5%
T	44072	6.9%
O	37894	5.9%
E	29554	4.6%
1	24060	3.8%
B	21838	3.4%
R	21838	3.4%
Other values (27)	207613	32.5%

bbl
Real number (ℝ)

High correlation Missing

Distinct	19057
Distinct (%)	34.7%
Missing	4054
Missing (%)	6.9%
Infinite	0
Infinite (%)	0.0%
Mean	2.5644265 × 10⁹

Minimum	0
Maximum	5.2700005 × 10⁹
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	460.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1.00414 × 10⁹
Q1	1.01443 × 10⁹
median	3.0115 × 10⁹
Q3	4.00659 × 10⁹
95-th percentile	4.1404801 × 10⁹
Maximum	5.2700005 × 10⁹
Range	5.2700005 × 10⁹
Interquartile range (IQR)	2.99216 × 10⁹

Descriptive statistics

Standard deviation	1.3009651 × 10⁹
Coefficient of variation (CV)	0.50731231
Kurtosis	-1.3553835
Mean	2.5644265 × 10⁹
Median Absolute Deviation (MAD)	1.0382601 × 10⁹
Skewness	0.057951962
Sum	1.4068187 × 10¹⁴
Variance	1.6925102 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4050590011	693	1.2%
5007350081	411	0.7%
1015640024	146	0.2%
4032340173	91	0.2%
3027790001	88	0.1%
3033930049	85	0.1%
1018770031	76	0.1%
1000917502	72	0.1%
1010737505	69	0.1%
3039300028	64	0.1%
Other values (19047)	53064	90.1%
(Missing)	4054	6.9%

Value	Count	Frequency (%)
0	2	< 0.1%
1000010111	1	< 0.1%
1000020001	6	< 0.1%
1000020002	3	< 0.1%
1000030001	3	< 0.1%
1000047501	1	< 0.1%
1000070027	1	< 0.1%
1000070028	3	< 0.1%
1000070031	7	< 0.1%
1000070035	7	< 0.1%

Value	Count	Frequency (%)
5270000501	2	< 0.1%
5240009996	1	< 0.1%
5200479999	1	< 0.1%
5080470031	1	< 0.1%
5080470021	1	< 0.1%
5080430019	2	< 0.1%
5080430001	2	< 0.1%
5080340100	1	< 0.1%
5080260016	2	< 0.1%
5080260008	1	< 0.1%

borough
Categorical

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

MANHATTAN	19639
BROOKLYN	16056
QUEENS	13575
BRONX	5778
STATEN ISLAND	2402

Length

Max length	13
Median length	11
Mean length	7.8566361
Min length	5

Characters and Unicode

Total characters	462858
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BROOKLYN
2nd row	BRONX
3rd row	MANHATTAN
4th row	BROOKLYN
5th row	BROOKLYN

Common Values

Value	Count	Frequency (%)
MANHATTAN	19639	33.3%
BROOKLYN	16056	27.3%
QUEENS	13575	23.0%
BRONX	5778	9.8%
STATEN ISLAND	2402	4.1%
Unspecified	1463	2.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	19639	32.0%
brooklyn	16056	26.2%
queens	13575	22.1%
bronx	5778	9.4%
staten	2402	3.9%
island	2402	3.9%
unspecified	1463	2.4%

Most occurring characters

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	462858	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	462858	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	462858	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

x_coordinate_state_plane
Real number (ℝ)

High correlation Missing

Distinct	20541
Distinct (%)	35.8%
Missing	1566
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	1001122.7

Minimum	914084
Maximum	1067128
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.4 KiB

Quantile statistics

Minimum	914084
5-th percentile	976433
Q1	987769
median	997470
Q3	1013515
95-th percentile	1038929.2
Maximum	1067128
Range	153044
Interquartile range (IQR)	25746

Descriptive statistics

Standard deviation	21552.248
Coefficient of variation (CV)	0.021528079
Kurtosis	1.1354908
Mean	1001122.7
Median Absolute Deviation (MAD)	11185
Skewness	0.0047316847
Sum	5.7411382 × 10¹⁰
Variance	4.644994 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1035940	694	1.2%
946124	296	0.5%
998687	155	0.3%
1026862	91	0.2%
997787	88	0.1%
982367	82	0.1%
946097	77	0.1%
993651	75	0.1%
985799	69	0.1%
1017293	64	0.1%
Other values (20531)	55656	94.5%
(Missing)	1566	2.7%

Value	Count	Frequency (%)
914084	2	< 0.1%
914381	1	< 0.1%
914616	4	< 0.1%
914856	1	< 0.1%
915031	2	< 0.1%
915092	1	< 0.1%
915172	3	< 0.1%
915191	1	< 0.1%
915252	1	< 0.1%
915470	1	< 0.1%

Value	Count	Frequency (%)
1067128	1	< 0.1%
1066911	1	< 0.1%
1066626	2	< 0.1%
1066623	1	< 0.1%
1066615	1	< 0.1%
1066613	3	< 0.1%
1066604	1	< 0.1%
1066596	1	< 0.1%
1066589	2	< 0.1%
1066413	1	< 0.1%

y_coordinate_state_plane
Real number (ℝ)

High correlation Missing

Distinct	22040
Distinct (%)	38.4%
Missing	1564
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	204170.52

Minimum	121374
Maximum	271861
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.4 KiB

Quantile statistics

Minimum	121374
5-th percentile	158344.8
Q1	187605
median	205155
Q3	218497
95-th percentile	250186.2
Maximum	271861
Range	150487
Interquartile range (IQR)	30892

Descriptive statistics

Standard deviation	26241.341
Coefficient of variation (CV)	0.12852659
Kurtosis	-0.17784387
Mean	204170.52
Median Absolute Deviation (MAD)	15484
Skewness	-0.085459416
Sum	1.1708975 × 10¹⁰
Variance	6.8860797 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
216775	694	1.2%
162287	300	0.5%
221604	146	0.2%
201883	92	0.2%
198444	88	0.1%
162281	77	0.1%
230741	75	0.1%
197857	71	0.1%
216568	69	0.1%
188272	66	0.1%
Other values (22030)	55671	94.5%
(Missing)	1564	2.7%

Value	Count	Frequency (%)
121374	1	< 0.1%
124349	1	< 0.1%
124868	1	< 0.1%
125016	1	< 0.1%
125152	1	< 0.1%
125358	1	< 0.1%
125376	1	< 0.1%
125422	6	< 0.1%
125508	1	< 0.1%
125513	2	< 0.1%

Value	Count	Frequency (%)
271861	4	< 0.1%
271054	1	< 0.1%
271005	2	< 0.1%
270768	3	< 0.1%
270176	1	< 0.1%
270038	1	< 0.1%
269885	2	< 0.1%
269699	1	< 0.1%
269605	8	< 0.1%
269588	2	< 0.1%

open_data_channel_type
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

ONLINE	24195
PHONE	21838
MOBILE	12848
UNKNOWN	28
OTHER	4

Length

Max length	7
Median length	6
Mean length	5.6297252
Min length	5

Characters and Unicode

Total characters	331664
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PHONE
2nd row	PHONE
3rd row	PHONE
4th row	ONLINE
5th row	MOBILE

Common Values

Value	Count	Frequency (%)
ONLINE	24195	41.1%
PHONE	21838	37.1%
MOBILE	12848	21.8%
UNKNOWN	28	< 0.1%
OTHER	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	24195	41.1%
phone	21838	37.1%
mobile	12848	21.8%
unknown	28	< 0.1%
other	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	70312	21.2%
O	58913	17.8%
E	58885	17.8%
L	37043	11.2%
I	37043	11.2%
H	21842	6.6%
P	21838	6.6%
M	12848	3.9%
B	12848	3.9%
U	28	< 0.1%
Other values (4)	64	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	331664	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	70312	21.2%
O	58913	17.8%
E	58885	17.8%
L	37043	11.2%
I	37043	11.2%
H	21842	6.6%
P	21838	6.6%
M	12848	3.9%
B	12848	3.9%
U	28	< 0.1%
Other values (4)	64	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	331664	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	70312	21.2%
O	58913	17.8%
E	58885	17.8%
L	37043	11.2%
I	37043	11.2%
H	21842	6.6%
P	21838	6.6%
M	12848	3.9%
B	12848	3.9%
U	28	< 0.1%
Other values (4)	64	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	331664	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	70312	21.2%
O	58913	17.8%
E	58885	17.8%
L	37043	11.2%
I	37043	11.2%
H	21842	6.6%
P	21838	6.6%
M	12848	3.9%
B	12848	3.9%
U	28	< 0.1%
Other values (4)	64	< 0.1%

park_facility_name
Categorical

Imbalance

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

Unspecified	58900
MORRIS PARK BAKE SHOP	4
SALSA CON FUEGO	1
PARISI BAKERY	1
DJ REYNOLDS PUB AND RESTAURANT	1
Other values (6)	6

Length

Max length	30
Median length	11
Mean length	11.001443
Min length	7

Characters and Unicode

Total characters	648128
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	Unspecified
2nd row	Unspecified
3rd row	Unspecified
4th row	Unspecified
5th row	Unspecified

Common Values

Value	Count	Frequency (%)
Unspecified	58900	> 99.9%
MORRIS PARK BAKE SHOP	4	< 0.1%
SALSA CON FUEGO	1	< 0.1%
PARISI BAKERY	1	< 0.1%
DJ REYNOLDS PUB AND RESTAURANT	1	< 0.1%
WENDY'S	1	< 0.1%
LE PAIN QUOTIDIEN	1	< 0.1%
MCDONALD'S	1	< 0.1%
HAI SUN RESTAURANT	1	< 0.1%
MASTER SMOOTHIE	1	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
unspecified	58900	99.9%
morris	4	< 0.1%
park	4	< 0.1%
bake	4	< 0.1%
shop	4	< 0.1%
restaurant	2	< 0.1%
salsa	1	< 0.1%
fuego	1	< 0.1%
parisi	1	< 0.1%
bakery	1	< 0.1%
Other values (17)	17	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	117800	18.2%
i	117800	18.2%
U	58906	9.1%
s	58900	9.1%
n	58900	9.1%
p	58900	9.1%
c	58900	9.1%
f	58900	9.1%
d	58900	9.1%
	26	< 0.1%
Other values (23)	196	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	648128	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	117800	18.2%
i	117800	18.2%
U	58906	9.1%
s	58900	9.1%
n	58900	9.1%
p	58900	9.1%
c	58900	9.1%
f	58900	9.1%
d	58900	9.1%
	26	< 0.1%
Other values (23)	196	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	648128	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	117800	18.2%
i	117800	18.2%
U	58906	9.1%
s	58900	9.1%
n	58900	9.1%
p	58900	9.1%
c	58900	9.1%
f	58900	9.1%
d	58900	9.1%
	26	< 0.1%
Other values (23)	196	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	648128	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	117800	18.2%
i	117800	18.2%
U	58906	9.1%
s	58900	9.1%
n	58900	9.1%
p	58900	9.1%
c	58900	9.1%
f	58900	9.1%
d	58900	9.1%
	26	< 0.1%
Other values (23)	196	< 0.1%

park_borough
Categorical

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.4 KiB

MANHATTAN	19639
BROOKLYN	16056
QUEENS	13575
BRONX	5778
STATEN ISLAND	2402

Length

Max length	13
Median length	11
Mean length	7.8566361
Min length	5

Characters and Unicode

Total characters	462858
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BROOKLYN
2nd row	BRONX
3rd row	MANHATTAN
4th row	BROOKLYN
5th row	BROOKLYN

Common Values

Value	Count	Frequency (%)
MANHATTAN	19639	33.3%
BROOKLYN	16056	27.3%
QUEENS	13575	23.0%
BRONX	5778	9.8%
STATEN ISLAND	2402	4.1%
Unspecified	1463	2.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	19639	32.0%
brooklyn	16056	26.2%
queens	13575	22.1%
bronx	5778	9.4%
staten	2402	3.9%
island	2402	3.9%
unspecified	1463	2.4%

Most occurring characters

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	462858	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	462858	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	462858	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	79491	17.2%
A	63721	13.8%
T	44082	9.5%
O	37890	8.2%
E	29552	6.4%
B	21834	4.7%
R	21834	4.7%
H	19639	4.2%
M	19639	4.2%
L	18458	4.0%
Other values (17)	106718	23.1%

latitude
Real number (ℝ)

High correlation Missing

Distinct	25732
Distinct (%)	44.9%
Missing	1569
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	40.727031

Minimum	40.49957
Maximum	40.912828
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.4 KiB

Quantile statistics

Minimum	40.49957
5-th percentile	40.601295
Q1	40.68154
median	40.729744
Q3	40.766347
95-th percentile	40.853346
Maximum	40.912828
Range	0.41325788
Interquartile range (IQR)	0.084806712

Descriptive statistics

Standard deviation	0.072026934
Coefficient of variation (CV)	0.001768529
Kurtosis	-0.17747501
Mean	40.727031
Median Absolute Deviation (MAD)	0.042470068
Skewness	-0.085756609
Sum	2335450.9
Variance	0.0051878793
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.76152265	694	1.2%
40.6120347	296	0.5%
40.77491631	146	0.2%
40.72069629	91	0.2%
40.71134933	88	0.1%
40.61201811	77	0.1%
40.80000172	75	0.1%
40.70974831	71	0.1%
40.76110546	69	0.1%
40.68337824	64	0.1%
Other values (25722)	55673	94.5%
(Missing)	1569	2.7%

Value	Count	Frequency (%)
40.49956978	1	< 0.1%
40.50775363	1	< 0.1%
40.50914304	1	< 0.1%
40.50954848	1	< 0.1%
40.50992911	1	< 0.1%
40.51049806	1	< 0.1%
40.51054699	1	< 0.1%
40.51067378	6	< 0.1%
40.51091083	1	< 0.1%
40.51092453	2	< 0.1%

Value	Count	Frequency (%)
40.91282765	4	< 0.1%
40.91060759	1	< 0.1%
40.91047872	1	< 0.1%
40.91047309	1	< 0.1%
40.90982838	3	< 0.1%
40.90820392	1	< 0.1%
40.90782747	1	< 0.1%
40.90740538	2	< 0.1%
40.90689522	1	< 0.1%
40.90659041	2	< 0.1%

longitude
Real number (ℝ)

High correlation Missing

Distinct	25732
Distinct (%)	44.9%
Missing	1569
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	-73.939096

Minimum	-74.252343
Maximum	-73.700929
Zeros	0
Zeros (%)	0.0%
Negative	57344
Negative (%)	97.3%
Memory size	460.4 KiB

Quantile statistics

Minimum	-74.252343
5-th percentile	-74.028162
Q1	-73.987303
median	-73.952337
Q3	-73.894381
95-th percentile	-73.802681
Maximum	-73.700929
Range	0.55141369
Interquartile range (IQR)	0.092922131

Descriptive statistics

Standard deviation	0.0777343
Coefficient of variation (CV)	-0.0010513288
Kurtosis	1.1247575
Mean	-73.939096
Median Absolute Deviation (MAD)	0.040367762
Skewness	0.0074441299
Sum	-4239963.5
Variance	0.0060426214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.81341016	694	1.2%
-74.13731846	296	0.5%
-73.94787507	146	0.2%
-73.84627407	91	0.2%
-73.95117114	88	0.1%
-74.13741567	77	0.1%
-73.96604481	75	0.1%
-74.00679194	71	0.1%
-73.99440848	69	0.1%
-73.88086167	64	0.1%
Other values (25722)	55673	94.5%
(Missing)	1569	2.7%

Value	Count	Frequency (%)
-74.25234297	2	< 0.1%
-74.2512771	1	< 0.1%
-74.25043315	4	< 0.1%
-74.24956219	1	< 0.1%
-74.24893041	2	< 0.1%
-74.24871018	1	< 0.1%
-74.24843668	3	< 0.1%
-74.24836242	1	< 0.1%
-74.24814344	1	< 0.1%
-74.24734551	1	< 0.1%

Value	Count	Frequency (%)
-73.70092928	1	< 0.1%
-73.70171308	1	< 0.1%
-73.70268276	2	< 0.1%
-73.70269361	1	< 0.1%
-73.70272256	1	< 0.1%
-73.7027297	3	< 0.1%
-73.70276236	1	< 0.1%
-73.70279129	1	< 0.1%
-73.70281653	2	< 0.1%
-73.70351185	1	< 0.1%

location
Text

Missing

Distinct	25732
Distinct (%)	44.9%
Missing	1569
Missing (%)	2.7%
Memory size	460.4 KiB

Length

Max length	141
Median length	140
Mean length	140.06805
Min length	136

Characters and Unicode

Total characters	8032062
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15005 ?
Unique (%)	26.2%

Sample

1st row	{'latitude': '40.577479337191384', 'longitude': '-73.9620829225648', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
2nd row	{'latitude': '40.8558288801221', 'longitude': '-73.85555931275691', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
3rd row	{'latitude': '40.74758418018265', 'longitude': '-73.9864914082603', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
4th row	{'latitude': '40.71827775344117', 'longitude': '-73.959946580784', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
5th row	{'latitude': '40.59326974931518', 'longitude': '-73.9607993127448', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}

Value	Count	Frequency (%)
	229376	30.8%
latitude	57344	7.7%
longitude	57344	7.7%
human_address	57344	7.7%
state	57344	7.7%
address	57344	7.7%
city	57344	7.7%
zip	57344	7.7%
73.81341016404748	694	0.1%
40.76152264872703	694	0.1%
Other values (51462)	113300	15.2%

Most occurring characters

Value	Count	Frequency (%)
"	917504	11.4%
'	688128	8.6%
	688128	8.6%
:	401408	5.0%
d	344064	4.3%
t	344064	4.3%
,	286720	3.6%
e	286720	3.6%
s	286720	3.6%
a	286720	3.6%
Other values (28)	3501886	43.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8032062	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
"	917504	11.4%
'	688128	8.6%
	688128	8.6%
:	401408	5.0%
d	344064	4.3%
t	344064	4.3%
,	286720	3.6%
e	286720	3.6%
s	286720	3.6%
a	286720	3.6%
Other values (28)	3501886	43.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8032062	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
"	917504	11.4%
'	688128	8.6%
	688128	8.6%
:	401408	5.0%
d	344064	4.3%
t	344064	4.3%
,	286720	3.6%
e	286720	3.6%
s	286720	3.6%
a	286720	3.6%
Other values (28)	3501886	43.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8032062	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
"	917504	11.4%
'	688128	8.6%
	688128	8.6%
:	401408	5.0%
d	344064	4.3%
t	344064	4.3%
,	286720	3.6%
e	286720	3.6%
s	286720	3.6%
a	286720	3.6%
Other values (28)	3501886	43.6%

closed_date
Date

Missing

Distinct	49129
Distinct (%)	94.4%
Missing	6875
Missing (%)	11.7%
Memory size	460.4 KiB

Minimum	2019-01-25 10:20:32
Maximum	2024-09-23 12:59:03

Histogram with fixed size bins (bins=50)

resolution_description
Categorical

High correlation Imbalance Missing

Distinct	15
Distinct (%)	< 0.1%
Missing	5769
Missing (%)	9.8%
Memory size	460.4 KiB

This SR was administratively closed. The issue you reported was addressed.	49035
The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2121
The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	1518
The Department of Health and Mental Hygiene has reviewed your Service Request. A warning letter has been sent to the responsible party notifying them to correct the condition. An inspector will be dispatched if needed. If the condition persists 21 days after the initial report, please call 311 to file another Service Request.	398
The Department of Health and Mental Hygiene has sent an official warning to the establishment. If the situation persists 45 days after the initial report, call 311 and file a new Service Reqeust.	28
Other values (10)	44

Length

Max length	495
Median length	74
Mean length	90.328899
Min length	74

Characters and Unicode

Total characters	4800439
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	This SR was administratively closed. The issue you reported was addressed.
2nd row	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.
3rd row	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.
4th row	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.
5th row	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.

Common Values

Value	Count	Frequency (%)
This SR was administratively closed. The issue you reported was addressed.	49035	83.2%
The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2121	3.6%
The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	1518	2.6%
The Department of Health and Mental Hygiene has reviewed your Service Request. A warning letter has been sent to the responsible party notifying them to correct the condition. An inspector will be dispatched if needed. If the condition persists 21 days after the initial report, please call 311 to file another Service Request.	398	0.7%
The Department of Health and Mental Hygiene has sent an official warning to the establishment. If the situation persists 45 days after the initial report, call 311 and file a new Service Reqeust.	28	< 0.1%
The Department of Health and Mental Hygiene regulates restaurants and other establishments that mostly sell food which is prepared on the premises. New York State Agriculture and Markets regulates those establishments that mostly sell pre-packaged food, including supermarkets, bodegas, green markets, fish and meat markets, and delis. This Service Request involves an establishment under the jurisdiction of the New York State Agriculture and Markets. For complaint status, call (718) 722-2876.	13	< 0.1%
The Department of Health and Mental Hygiene has determined that this issue is not within its jurisdiction; it cannot be determined if another agency would regulate the issue reported. This Service Request has been closed.	10	< 0.1%
The Department of Health and Mental Hygiene has investigated the complaint. No violations were cited and no further action will be taken.	7	< 0.1%
The Department of Health and Mental Hygiene has investigated the complaint. No violations were cited and no further action will be taken.	5	< 0.1%
The Department of Health and Mental Hygiene has investigated the complaint and issued a Notice of Violation. No further action will be taken.	2	< 0.1%
Other values (5)	7	< 0.1%
(Missing)	5769	9.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
was	98072	13.7%
the	65816	9.2%
this	49068	6.9%
issue	49055	6.9%
closed	49048	6.9%
reported	49045	6.9%
administratively	49035	6.8%
sr	49035	6.8%
you	49035	6.8%
addressed	49035	6.8%
Other values (116)	159724	22.3%

Most occurring characters

Value	Count	Frequency (%)
	664955	13.9%
e	495432	10.3%
s	487857	10.2%
i	338213	7.0%
a	332442	6.9%
d	316448	6.6%
t	272980	5.7%
r	243640	5.1%
o	215543	4.5%
n	141707	3.0%
Other values (45)	1291222	26.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4800439	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	664955	13.9%
e	495432	10.3%
s	487857	10.2%
i	338213	7.0%
a	332442	6.9%
d	316448	6.6%
t	272980	5.7%
r	243640	5.1%
o	215543	4.5%
n	141707	3.0%
Other values (45)	1291222	26.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4800439	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	664955	13.9%
e	495432	10.3%
s	487857	10.2%
i	338213	7.0%
a	332442	6.9%
d	316448	6.6%
t	272980	5.7%
r	243640	5.1%
o	215543	4.5%
n	141707	3.0%
Other values (45)	1291222	26.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4800439	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	664955	13.9%
e	495432	10.3%
s	487857	10.2%
i	338213	7.0%
a	332442	6.9%
d	316448	6.6%
t	272980	5.7%
r	243640	5.1%
o	215543	4.5%
n	141707	3.0%
Other values (45)	1291222	26.9%

resolution_action_updated_date
Date

Missing

Distinct	37308
Distinct (%)	70.2%
Missing	5769
Missing (%)	9.8%
Memory size	460.4 KiB

Minimum	2019-01-25 10:20:32
Maximum	2024-09-23 12:59:05

Histogram with fixed size bins (bins=50)

due_date
Date

Missing

Distinct	5235
Distinct (%)	> 99.9%
Missing	53677
Missing (%)	91.1%
Memory size	460.4 KiB

Minimum	2019-01-25 09:31:31
Maximum	2019-08-26 15:46:45

Histogram with fixed size bins (bins=50)

facility_type
Unsupported

Missing Rejected Unsupported

Missing	58913
Missing (%)	100.0%
Memory size	460.4 KiB

Interactions

Correlations

	address_type	bbl	borough	descriptor	incident_zip	latitude	location_type	longitude	open_data_channel_type	park_borough	park_facility_name	resolution_description	status	unique_key	x_coordinate_state_plane	y_coordinate_state_plane
address_type	1.000	0.100	0.015	0.065	0.041	0.029	0.066	0.026	0.122	0.015	0.000	0.110	0.037	0.165	0.026	0.029
bbl	0.100	1.000	0.894	0.069	0.842	-0.412	0.021	0.496	0.073	0.894	0.000	0.008	0.031	-0.046	0.496	-0.411
borough	0.015	0.894	1.000	0.092	0.685	0.561	0.029	0.609	0.117	1.000	0.005	0.029	0.038	0.093	0.609	0.562
descriptor	0.065	0.069	0.092	1.000	0.074	0.062	0.074	0.067	0.197	0.092	0.000	0.091	0.082	0.098	0.067	0.062
incident_zip	0.041	0.842	0.685	0.074	1.000	-0.374	0.025	0.624	0.073	0.685	0.000	0.009	0.027	-0.021	0.625	-0.374
latitude	0.029	-0.412	0.561	0.062	-0.374	1.000	0.022	0.326	0.072	0.561	0.000	0.014	0.027	0.010	0.325	1.000
location_type	0.066	0.021	0.029	0.074	0.025	0.022	1.000	0.032	0.149	0.029	0.011	0.052	0.049	0.204	0.032	0.022
longitude	0.026	0.496	0.609	0.067	0.624	0.326	0.032	1.000	0.082	0.609	0.000	0.009	0.034	-0.020	1.000	0.326
open_data_channel_type	0.122	0.073	0.117	0.197	0.073	0.072	0.149	0.082	1.000	0.117	0.000	0.040	0.039	0.095	0.081	0.072
park_borough	0.015	0.894	1.000	0.092	0.685	0.561	0.029	0.609	0.117	1.000	0.005	0.029	0.038	0.093	0.609	0.562
park_facility_name	0.000	0.000	0.005	0.000	0.000	0.000	0.011	0.000	0.000	0.005	1.000	0.000	0.000	0.006	0.000	0.000
resolution_description	0.110	0.008	0.029	0.091	0.009	0.014	0.052	0.009	0.040	0.029	0.000	1.000	0.601	0.282	0.009	0.014
status	0.037	0.031	0.038	0.082	0.027	0.027	0.049	0.034	0.039	0.038	0.000	0.601	1.000	0.653	0.034	0.027
unique_key	0.165	-0.046	0.093	0.098	-0.021	0.010	0.204	-0.020	0.095	0.093	0.006	0.282	0.653	1.000	-0.020	0.010
x_coordinate_state_plane	0.026	0.496	0.609	0.067	0.625	0.325	0.032	1.000	0.081	0.609	0.000	0.009	0.034	-0.020	1.000	0.326
y_coordinate_state_plane	0.029	-0.411	0.562	0.062	-0.374	1.000	0.022	0.326	0.072	0.562	0.000	0.014	0.027	0.010	0.326	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	unique_key	created_date	agency	agency_name	complaint_type	descriptor	location_type	incident_zip	incident_address	street_name	cross_street_1	cross_street_2	intersection_street_1	intersection_street_2	address_type	city	landmark	status	community_board	bbl	borough	x_coordinate_state_plane	y_coordinate_state_plane	open_data_channel_type	park_facility_name	park_borough	latitude	longitude	location	closed_date	resolution_description	resolution_action_updated_date	due_date	facility_type
0	62605571	2024-09-29T23:42:42.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Bare Hands in Contact w/ Food	Restaurant/Bar/Deli/Bakery	11235.0	523 BRIGHTON BEACH AVENUE	BRIGHTON BEACH AVENUE	BRIGHTON 5 STREET	BRIGHTON 6 STREET	BRIGHTON 5 STREET	BRIGHTON 6 STREET	ADDRESS	BROOKLYN	BRIGHTON BEACH AVENUE	In Progress	13 BROOKLYN	3.086750e+09	BROOKLYN	994783.0	149670.0	PHONE	Unspecified	BROOKLYN	40.577479	-73.962083	{'latitude': '40.577479337191384', 'longitude': '-73.9620829225648', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
1	62601936	2024-09-29T21:52:07.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	10461.0	2117 WILLIAMBRIDGE ROAD	WILLIAMBRIDGE ROAD	LYDIG AVENUE	PELHAM PARKWAY SOUTH	LYDIG AVENUE	PELHAM PARKWAY SOUTH	ADDRESS	BRONX	WILLIAMSBRIDGE ROAD	In Progress	11 BRONX	2.043320e+09	BRONX	1024207.0	251112.0	PHONE	Unspecified	BRONX	40.855829	-73.855559	{'latitude': '40.8558288801221', 'longitude': '-73.85555931275691', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
2	62602735	2024-09-29T21:22:45.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	10001.0	31 WEST 32 STREET	WEST 32 STREET	5 AVENUE	BROADWAY	5 AVENUE	BROADWAY	ADDRESS	NEW YORK	WEST 32 STREET	In Progress	05 MANHATTAN	1.008340e+09	MANHATTAN	987993.0	211642.0	PHONE	Unspecified	MANHATTAN	40.747584	-73.986491	{'latitude': '40.74758418018265', 'longitude': '-73.9864914082603', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
3	62605500	2024-09-29T21:14:24.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	NaN	114	NaN	BERRY STRE	MIKE LEE	BERRY STRE	MIKE LEE	NaN	Brooklyn	NaN	In Progress	Unspecified BROOKLYN	3.023340e+09	BROOKLYN	995353.0	200967.0	ONLINE	Unspecified	BROOKLYN	40.718278	-73.959947	{'latitude': '40.71827775344117', 'longitude': '-73.959946580784', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
4	62603635	2024-09-29T21:05:25.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Bare Hands in Contact w/ Food	Restaurant/Bar/Deli/Bakery	11223.0	2605 CONEY ISLAND AVENUE	CONEY ISLAND AVENUE	AVENUE W	LANCASTER AVENUE	AVENUE W	LANCASTER AVENUE	ADDRESS	BROOKLYN	CONEY ISLAND AVENUE	In Progress	15 BROOKLYN	3.073940e+09	BROOKLYN	995137.0	155423.0	MOBILE	Unspecified	BROOKLYN	40.593270	-73.960799	{'latitude': '40.59326974931518', 'longitude': '-73.9607993127448', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
5	62603805	2024-09-29T19:26:50.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	11215.0	192 PROSPECT PARK WEST	PROSPECT PARK WEST	NaN	15 STREET	NaN	15 STREET	ADDRESS	BROOKLYN	PROSPECT PARK WEST	In Progress	06 BROOKLYN	3.011030e+09	BROOKLYN	989873.0	180198.0	MOBILE	Unspecified	BROOKLYN	40.661277	-73.979733	{'latitude': '40.661276811907456', 'longitude': '-73.9797326921662', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
6	62602734	2024-09-29T19:16:42.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	No Permit or License	Restaurant/Bar/Deli/Bakery	11417.0	93-10 LIBERTY AVENUE	LIBERTY AVENUE	93 STREET	94 STREET	93 STREET	94 STREET	ADDRESS	OZONE PARK	LIBERTY AVENUE	In Progress	10 QUEENS	4.091620e+09	QUEENS	1027054.0	187128.0	MOBILE	Unspecified	QUEENS	40.680196	-73.845675	{'latitude': '40.68019640487362', 'longitude': '-73.84567519025673', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
7	62602005	2024-09-29T17:55:03.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	10014.0	567 HUDSON STREET	HUDSON STREET	PERRY STREET	WEST 11 STREET	PERRY STREET	WEST 11 STREET	ADDRESS	NEW YORK	HUDSON STREET	In Progress	02 MANHATTAN	1.006330e+09	MANHATTAN	982591.0	207327.0	ONLINE	Unspecified	MANHATTAN	40.735741	-74.005986	{'latitude': '40.73574121648932', 'longitude': '-74.00598631322032', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
8	62606493	2024-09-29T17:43:04.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Toilet Facility	Restaurant/Bar/Deli/Bakery	11209.0	9243 4 AVENUE	4 AVENUE	93 STREET	94 STREET	93 STREET	94 STREET	ADDRESS	BROOKLYN	4 AVENUE	In Progress	10 BROOKLYN	3.061080e+09	BROOKLYN	975770.0	164215.0	PHONE	Unspecified	BROOKLYN	40.617405	-74.030545	{'latitude': '40.61740462322561', 'longitude': '-74.03054487148385', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN
9	62604247	2024-09-29T16:43:02.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Food Contaminated	Restaurant/Bar/Deli/Bakery	10038.0	164 WILLIAM STREET	WILLIAM STREET	ANN STREET	BEEKMAN STREET	ANN STREET	BEEKMAN STREET	ADDRESS	NEW YORK	WILLIAM STREET	In Progress	01 MANHATTAN	1.000930e+09	MANHATTAN	982655.0	198034.0	ONLINE	Unspecified	MANHATTAN	40.710234	-74.005753	{'latitude': '40.71023419230766', 'longitude': '-74.00575317413539', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	NaN	NaN	NaN	NaN

	unique_key	created_date	agency	agency_name	complaint_type	descriptor	location_type	incident_zip	incident_address	street_name	cross_street_1	cross_street_2	intersection_street_1	intersection_street_2	address_type	city	landmark	status	community_board	bbl	borough	x_coordinate_state_plane	y_coordinate_state_plane	open_data_channel_type	park_facility_name	park_borough	latitude	longitude	location	closed_date	resolution_description	resolution_action_updated_date	due_date	facility_type
58903	41318001	2019-01-01T12:57:21.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Letter Grading	Restaurant/Bar/Deli/Bakery	10309.0	4864 ARTHUR KIL ROAD	ARTHUR KIL ROAD	SOUTH BRIDGE STREET	RICHMOND VALLEY ROAD	NaN	NaN	ADDRESS	STATEN ISLAND	NaN	Closed	03 STATEN ISLAND	5.075840e+09	STATEN ISLAND	917747.0	130119.0	PHONE	Unspecified	STATEN ISLAND	40.523573	-74.239207	{'latitude': '40.5235725885887', 'longitude': '-74.23920715187802', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:15.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:16.000	2019-03-02T12:57:21.000	NaN
58904	41314982	2019-01-01T12:18:43.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Food Spoiled	Restaurant/Bar/Deli/Bakery	11368.0	96-23 57 AVENUE	57 AVENUE	96 STREET	97 STREET	NaN	NaN	ADDRESS	CORONA	NaN	Closed	04 QUEENS	4.019040e+09	QUEENS	1021789.0	207822.0	PHONE	Unspecified	QUEENS	40.737020	-73.864542	{'latitude': '40.73702035936368', 'longitude': '-73.86454212450096', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:16.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:16.000	2019-03-02T12:18:43.000	NaN
58905	41316449	2019-01-01T11:32:20.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	11373.0	77-00 QUEENS BOULEVARD	QUEENS BOULEVARD	IRELAND STREET	ALBION AVENUE	NaN	NaN	ADDRESS	ELMHURST	NaN	Closed	04 QUEENS	4.024520e+09	QUEENS	1015767.0	208332.0	PHONE	Unspecified	QUEENS	40.738444	-73.886270	{'latitude': '40.73844369159779', 'longitude': '-73.88626983778089', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:17.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:17.000	2019-03-02T11:32:20.000	NaN
58906	41318974	2019-01-01T11:06:20.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Handwashing	Other (Explain Below)	11217.0	576 ATLANTIC AVENUE	ATLANTIC AVENUE	3 AVENUE	4 AVENUE	3 AVENUE	4 AVENUE	ADDRESS	BROOKLYN	NaN	Closed	02 BROOKLYN	3.001860e+09	BROOKLYN	990116.0	188693.0	PHONE	Unspecified	BROOKLYN	40.684594	-73.978849	{'latitude': '40.684593521742336', 'longitude': '-73.97884944004804', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2024-06-03T10:07:59.000	This SR was administratively closed. The issue you reported was addressed.	2024-06-03T10:08:06.000	2019-02-07T11:06:20.000	NaN
58907	41317566	2019-01-01T10:50:27.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	11215.0	225 7 AVENUE	7 AVENUE	3 STREET	4 STREET	NaN	NaN	ADDRESS	BROOKLYN	NaN	Closed	06 BROOKLYN	3.010800e+09	BROOKLYN	990092.0	183390.0	ONLINE	Unspecified	BROOKLYN	40.670038	-73.978941	{'latitude': '40.67003800101288', 'longitude': '-73.9789405717176', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:15.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:15.000	2019-03-02T10:50:27.000	NaN
58908	41316420	2019-01-01T10:40:40.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Rodents/Insects/Garbage	Restaurant/Bar/Deli/Bakery	10014.0	75 GREENWICH AVENUE	GREENWICH AVENUE	7 AVENUE	BANK STREET	NaN	NaN	ADDRESS	NEW YORK	NaN	Closed	02 MANHATTAN	1.006140e+09	MANHATTAN	983917.0	207684.0	ONLINE	Unspecified	MANHATTAN	40.736721	-74.001202	{'latitude': '40.73672124264221', 'longitude': '-74.0012016103804', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:17.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:17.000	2019-03-02T10:40:40.000	NaN
58909	41318119	2019-01-01T09:56:59.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Pet/Animal	Restaurant/Bar/Deli/Bakery	11226.0	1603 CORTELYOU ROAD	CORTELYOU ROAD	EAST 16 STREET	EAST 17 STREET	NaN	NaN	ADDRESS	BROOKLYN	NaN	Closed	14 BROOKLYN	3.051470e+09	BROOKLYN	994404.0	173061.0	ONLINE	Unspecified	BROOKLYN	40.641683	-73.963412	{'latitude': '40.64168326471781', 'longitude': '-73.96341208990378', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:17.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:17.000	2019-03-02T09:56:59.000	NaN
58910	41314791	2019-01-01T08:38:30.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Toilet Facility	Restaurant/Bar/Deli/Bakery	10022.0	1066 2 AVENUE	2 AVENUE	EAST 56 STREET	EAST 57 STREET	NaN	NaN	ADDRESS	NEW YORK	NaN	Closed	06 MANHATTAN	1.013490e+09	MANHATTAN	993752.0	215704.0	ONLINE	Unspecified	MANHATTAN	40.758729	-73.965701	{'latitude': '40.758729026402136', 'longitude': '-73.96570127751059', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:17.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:17.000	2019-03-02T08:38:30.000	NaN
58911	41315010	2019-01-01T07:59:30.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Letter Grading	Restaurant/Bar/Deli/Bakery	10466.0	4045 LACONIA AVENUE	LACONIA AVENUE	EAST 227 STREET	EAST 228 STREET	NaN	NaN	ADDRESS	BRONX	NaN	Closed	12 BRONX	2.048740e+09	BRONX	1026284.0	262179.0	ONLINE	Unspecified	BRONX	40.886195	-73.847982	{'latitude': '40.88619471722822', 'longitude': '-73.8479817460043', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-03T06:18:17.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-03T06:18:17.000	2019-03-02T07:59:30.000	NaN
58912	41307236	2019-01-01T01:17:04.000	DOHMH	Department of Health and Mental Hygiene	Food Establishment	Kitchen/Food Prep Area	Restaurant/Bar/Deli/Bakery	11212.0	9323 CHURCH AVENUE	CHURCH AVENUE	LINDEN BOULEVARD	EAST 94 STREET	NaN	NaN	ADDRESS	BROOKLYN	NaN	Closed	17 BROOKLYN	3.046900e+09	BROOKLYN	1007207.0	177753.0	ONLINE	Unspecified	BROOKLYN	40.654538	-73.917263	{'latitude': '40.654537851407625', 'longitude': '-73.91726308878049', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	2019-03-02T06:18:22.000	The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.	2019-03-02T06:18:22.000	2019-03-02T01:17:04.000	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts